/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.company.common.dao.impl;

import com.company.common.dao.ProvinceDao;
import com.company.regis.db.BaseDao;
import com.company.regis.db.entity.Province;
import java.util.List;
import org.springframework.stereotype.Repository;

/**
 *
 * @author totoland
 */
@Repository("provinceDao")
public class ProvinceDaoImpl extends BaseDao implements ProvinceDao{

    @Override
    public List<Province> getAllProvince() {
        return findNativeQuery("SELECT PROVINCE_ID, PROVINCE_CODE, PROVINCE_NAME, GEO_ID FROM PROVINCE", Province.class);
    }

   
    
}
